﻿using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Common;

/// <summary>
/// Summary description for SearchNameFood
/// </summary>
public class SearchNameFood
{
	public SearchNameFood()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public static DataTable SearchNameFood1(string name)
    {
        DbCommand command = GenericDataAccess.CreateCommand();
        command.CommandText = "SearchFood";
        DbParameter param = command.CreateParameter();
        param.ParameterName = "@Name";
        param.Value = name;
        param.DbType = DbType.String;
        command.Parameters.Add(param);
        return GenericDataAccess.ExecuteSelectCommand(command);
    }                                                                                  
}
